* Program file for the project "Globalization and Working Conditions" (project-number fdz064) - 40RaessCS02var.do * Contents: preparation of variables for cross-section analysis 2002log using log\40RaessCS02var.logcountdrop if well2002=="Y"countdrop if well2002=="Z"count*drop if well2002=="C"count if well2002=="C"mvdecode _all, mv(-8,-9)**FIRST, we create a range of new dependent variables*standard weekly hoursgen stdhours=j20lab var stdhours "weekly standard hours"sum stdhours, detailgen stdhourslog=ln(stdhours)sum stdhourslog, detailgen stdhours01=stdhours/10lab var stdhours01 "weekly standard hours in hours"sum stdhours01, detail*overtimetab j27recode j27 (2=0)gen overtime=j27lab var overtime "is there overtime"tab overtime*paid overtimesum j29a, dcount if j29a==.count if j29a~=.recode j29a (.=0)sum j29a, dgen help_j29a=j29areplace help_j29a=1 if help_j29a>0gen povertime=help_j29alab var povertime "is there paid overtime"tab povertime*share of workers doing paid overtime, version A gen povertimepropA=j29alab var povertimepropA "share doing overtime A"sum povertimepropA, detail*share of workers doing paid overtime, version B replace j29a=0 if j27==0gen povertimepropB=j29alab var povertimepropB "share doing overtime B"sum povertimepropB, detail*part-timetab j42arecode j42a (2=0)gen parttime=j42alab var parttime "is there part-time"tab parttime*share of workers on part-time contracts, Agen parttimepropA=(j42tz/j41ges)*100lab var parttimepropA "share doing part-time A"sum parttimepropA, d*share of workers on part-time contracts, Breplace j42tz=0 if j42a==0gen parttimepropB=(j42tz/j41ges)*100lab var parttimepropB "share doing part-time B"sum parttimepropB, detail*fixed contractstab j43arecode j43a (2=0)gen fixedterm=j43alab var fixedterm "are there fixed-term contracts"tab fixedterm*share on fixed-term contracts, version Agen fixedtermpropA=(j43bef/j41ges)*100lab var fixedtermpropA "share on fixed-term contracts A"sum fixedtermpropA, detail*share on fixed-term contracts, version Breplace j43bef=0 if j43a==0gen fixedtermpropB=(j43bef/j41ges)*100lab var fixedtermpropB "share on fixed-term contracts B"sum fixedtermpropB, detail*temp contractstab j44crecode j44c (2=0)gen tempwk=j44clab var tempwk "are there temporary work contracts"tab tempwk*share temp contracts, version Agen tempwkpropA=(j44leih/(j44leih+j41ges))*100lab var tempwkpropA "share on temporary work contracts A"sum tempwkpropA, detail*share temp contracts, version Breplace j44leih=0 if j44c==0gen tempwkpropB=(j44leih/(j44leih+j41ges))*100lab var tempwkpropB "share on temporary work contracts B"sum tempwkpropB, detail*work time accountstab j22recode j22 (2 3=0)gen wta=j22lab var wta "is there working-time account"tab wta*share workers on working time accounts, version Acount if j23==.count if j23~=.recode j23 (.=0)sum j23, dgen help_j23=j23replace help_j23=1 if help_j23>0gen wta2=help_j23lab var wta2 "is there work time account 2"tab wta2gen wtapropA=j23lab var wtapropA "share on work time accounts A"sum wtapropA, d*share workers on working time accounts, version Breplace j23=0 if j22==2&j22==3gen wtapropB=j23lab var wtapropB "share on work time accounts B"sum wtapropB, d*We want to construct the dependent variable 'baltime' (an ordinal measure of working time account balancing time)count if j25a==.count if j25a~=.count if j25a==,count if j25a~=","count if j25b==.count if j25b~=.count if j25b==,count if j25b~=","count if j25c==.count if j25c~=.count if j25c==,count if j25c~=","count if j25d==.count if j25d~=.count if j25d==,count if j25d~=","count if j25e==.count if j25e~=.count if j25e==,count if j25e~=","recode j25b (1=2)recode j25c (1=3)recode j25d (1=4)gen baltime=j25a+j25b+j25c+j25dreplace baltime=0 if baltime>4&baltime~=.recode baltime (0=.)lab var baltime "balancing time of working time account"tab baltime*New recode of j30 (whether firm follows patterned bargaining), binary recoding: 0=no patterning; 1=following branch agreement or 'Haus-, Firmentarifvertrag'tab j30gen patternbargj30=j30recode patternbargj30 (3=0) (1 2=1)gen patternbarg=patternbargj30lab var patternbarg "firm follow industry or firm collective agreement"tab patternbarg* alternative pattern bargaining var where industry-level collective agreement only countstab j30gen patternbargBj30=j30recode patternbargBj30 (2 3=0) (1 =1)gen patternbargB=patternbargBj30lab var patternbargB "firm follow industry agreement only"tab patternbargBgen pripubj82=j82recode pripubj82 (4=1) (1 2 3 5=0) (6=.)gen pripub=pripubj82*We create a series of composite variables wrkcomp*wrkcompgen wrkcomp=povertime+fixedterm+tempwk+wtalab var wrkcomp "indice of flexibility"tab wrkcomp*wrkcomp1gen wrkcomp1=overtime+fixedterm+tempwk+wtalab var wrkcomp1 "indice of flexibility 1"tab wrkcomp1*wrkcomp2gen wrkcomp2=tempwk+fixedtermlab var wrkcomp2 "indice flexibility 2"sum wrkcomp2, detail*wrkcomp3gen wrkcomp3=tempwk+fixedterm+wtalab var wrkcomp3 "indice flexibility 3"sum wrkcomp3, detail*wrkcomp4gen wrkcomp4=(povertimepropA+fixedtermpropA+tempwkpropA+wtapropA)/4lab var wrkcomp4 "indice of flexibility 4"sum wrkcomp4, detail*wrkcomp5gen wrkcomp5=(povertimepropB+fixedtermpropB+tempwkpropB+wtapropB)/4lab var wrkcomp5 "indice of flexibility 5"sum wrkcomp5, detail*wrkcomp6gen wrkcomp6=(fixedtermpropA+tempwkpropA)/2lab var wrkcomp6 "indice of flexibility 6"sum wrkcomp6, detail*wrkcomp7gen wrkcomp7=(fixedtermpropB+tempwkpropB)/2lab var wrkcomp7 "indice of flexibility 7"sum wrkcomp7, detail*wrkcomp8gen wrkcomp8=(fixedtermpropB+tempwkpropB+wtapropB)/3lab var wrkcomp8 "indice of flexibility 8"sum wrkcomp8, detail**SECOND, we create a number of control variables* works counciltab j76recode j76 (2=0)gen wc=j76lab var wc "is there works council"tab wc*location in East or Westtab wo2002recode wo2002 (1=0) (2=1)gen locat=wo2002lab var locat "firm location East or West"tab locat*work packagesum j34gen wpack=j34/j41geslab var wpack "wage package"sum wpack, d*share unskilled workersgen unskill=(j41unge+j41einf)/(j41ges-j41aus-j41anw)lab var unskill "share of unskilled workers"sum unskill, detail*share production workersgen prodwrkrs=(j41unge+j41fach)/(j41ges-j41aus-j41anw)lab var prodwrkrs "share of production workers"sum prodwrkrs, detail* share of unskilled workers in productiongen unskilprodwrkrs=j41unge/(j41ges-j41aus-j41anw)lab unskilprodwrkrs "share of unskilled workers in production"sum unskilprodwrkrs, d* share of skilled workers in productiongen skilprodwrkrs=j41fach/(j41ges-j41aus-j41anw)lab skilprodwrkrs "share of skilled workers in production"sum skilprodwrkrs, d*firm sizegen size=j41geslab var size "total employment"sum size, detailgen size0001=size/1000lab var size0001 "total employment in '1000"sum size0001, detail*firm salesgen sales=j06lab var sales "sales"sum sales, detail*productivitygen pvty=j06/j41geslab var pvty "productivity"sum pvty, d*firm statustab j80recode j80 (1=1) (2 3 4=0)gen indest=j80lab var indest "single independent establishment"tab indest*In the testdata, there are only 11 establishments coded as 1, which we interpret as single independent establishments, all the rest are missing values (.). We assume that in the real data there will be 2, 3 and 4 for "Zentrale", "Niederlasssung", and "Mittelinstanz", respectively.*firm agetab j84recode j84 (1=0) (2=1)gen age=j84lab var age "establishment age"tab age*status as public or private firmtab j82gen pripubj82=j82recode pripubj82 (4=1) (1 2 3 5=0) (6=.)gen pripub=pripubj82lab var pripub "private-public ownership"tab pripub*for technology, we create two variables, one ordinal and one dummy variable*technology1 - ordinaltab j19gen techj19=j19recode techj19 (1=5) (2=4) (3=3) (4=2) (5=1)gen tech1=techj19lab var tech1 "state-of-art technology/ordinal"tab tech1drop techj19*technology2 - dummytab j19gen techj19=j19recode techj19 (1=1) (2/5=0)gen tech2=techj19lab var tech2 "state-of-art technology/dummy"tab tech2drop techj19*Now unemployment change 2000 to 2001, Bundesl�ndergen unemplch=bula2002recode unemplch (-9=.) (1=-0.1) (2=-0.7) (3=-0.3) (4=-0.8) (5=-0.5) (6=-0.7) (7=-0.5) (8=-0.5) (9=-0.3) (10=-1.0) (0 11=0.3) (12=0.4) (13=0.6) (14=0.5) (15=-0.5) (16=0.0)lab var unemplch "unemployment change"sum unemplch, d*Now unemployment level 2001, Bundesl�ndergen unempllvl=bula2002recode unempllvl (-9=.) (1=8.4) (2=8.3) (3=9.1) (4=12.4) (5=8.8) (6=6.6) (7=6.8) (8=4.9) (9=5.3) (10=9.0) (11=16.1) (12=17.4) (13=18.3) (14=17.5) (15=19.7) (16=15.3)recode unempllvl (0=11)lab var unempllvl "unemployment level 2001"tab unempllvl**THIRD, we create indusrty dummies (technique one)gen branch=j87blab var branch "branch"gen indust1=j87brecode indust1 (2/41=0)lab var indust1 "agriculture" gen indust2=j87brecode indust2 (2=1) (1=0) (3/41=0)lab var indust2 "mining"gen indust3=j87brecode indust3 (1/2=0) (3/18=1) (19/41=0)lab var indust3 "manufacturing"gen indust4=j87brecode indust4 (1/18=0) (19/20=1) (21/41=0)lab var indust4 "construction"gen indust5=j87brecode indust5 (1/20=0) (21/23=1) (24/41=0)lab var indust5 "wholesales, retail"gen indust6=j87brecode indust6 (1/23=0) (24/25=1) (26/41=0)lab var indust6 "transport and communiction"gen indust7=j87brecode indust7 (1/25=0) (26/27=1) (28/41=0)lab var indust7 "financial services"gen indust8=j87brecode indust8 (1/27=0) (28/32=1) (33/41=0)lab var indust8 "real estate, R&D, services mainly for firms"gen indust9=j87brecode indust9 (1/32=0) (33/38=1) (39/41=0)lab var indust9 "Health sector, education, culture, sport"gen indust10=j87brecode indust10 (1/38=0) (39/41=1)lab var indust10 "Interest organizations, public administration, defense"tab indust1tab indust2tab indust3tab indust4tab indust5tab indust6tab indust7tab indust8tab indust9tab indust10*I create the variable "metal industry" (NACE 28-35)gen metindust=j87brecode metindust (1/11=0) (12/17=1) (18/41=0)lab var metindust "metal industry"tab metindust*I create the variable "tradeable sector" (primary and secondary sectors)
gen tradeable=j87b
recode tradeable (1/18=1)(19/41=0)
lab var tradeable "tradeable sector"
tab tradeable


**FOURTH, our main independent variables are our globalization measures*We have two measure taken from the IAB-establishment panel dataset*foreign salesgen forsales=j10c+j10dlab var forsales "foreign sales"sum forsales, detail*squared foreign sales gen forsales2=forsales^2sum forsales2, d*dummy for exporting establishmentsgen export=forsalesreplace export=1 if forsales>0sum export, d*dummy for exporting establishments with more than 10% foreign salesgen export10=forsalesreplace export10=0 if forsales>0&forsales<10replace export10=1 if forsales>=10sum export10, d*dummy for exporting establishments with more than 20% foreign salesgen export20=forsalesreplace export20=0 if forsales>0&forsales<20replace export20=1 if forsales>=20sum export20, d*dummy for exporting establishments with more than 25% foreign salesgen export25=forsalesreplace export25=0 if forsales>0&forsales<25replace export25=1 if forsales>=25sum export25, d*foreign ownershipgen forowj82=j82recode forowj82 (3=1) (1 2 4 5=0) (6=.)gen forownership=forowj82lab var forownership "foreign ownership"tab forownership*We also use external globalization variables. We will now make our measures of international exposure/globalization variables by recoding the industry position of respondents, all with a recoding of the more detailed industry positions your recoding instructions allow, using your 'wz93_03' command.*gen help=uniform()*100000*gen wz93_03=int(help)*10 measures in total, including outward FDI, inward FDI, total FDI, total trade, net export rate, export orientation and import penetrationgen fdi2=wz93_03recode fdi2 (-9=.) (0=.) (10/19=0.006) (20/29=0.006) (50/59=0.006) (100/109=0.248) (110/119=0.248) (120/129=0.248) (130/139=0.248) (140/149=0.248) (150/159=0.079) (160/169=0.929) (170/179=0.476) (180/189=0.475) (190/199=0.733) (200/209=0.111) (210/219=0.226) (220/229=0.123) (230/239=0.28) (240/249=0.798) (250/259=0.284) (260/269=0.389) (270/279=0.144) (280/289=0.129) (290/299=0.223) (300/309=0.039) (310/319=0.467) (320/329=0.561) (330/339=0.308) (340/349=0.877) (350/359=0.293) (360/369=0.159) (370/379=0.214) (400/409=0.227) (410/419=0.227) (450/459=0.034) (500/509=0.15) (510/519=0.15) (520/529=0.15) (550/559=0.026) (600/609=0.114) (610/619=0.114) (620/629=0.114) (630/639=0.114) (640/649=0.234) (650/659=0.176) (660/669=0.303) (670/679=0.055) (700/709=0.01) (710/719=0.174) (720/729=0.124) (730/739=0.074) (740/749=0.033) (750/759=.) (800/809=0.006) (850/859=0.006) (900/909=0.007) (910/919=0.007) (920/929=0.007) (930/939=0.007) (950/959=.) (990/999=.) (1000/1999=0.006) (2000/2999=0.006) (5000/5999=0.006) (10000/10999=0.248) (11000/11999=0.248) (12000/12999=0.248) (13000/13999=0.248) (14000/14999=0.248) (15000/15999=0.079) (16000/16999=0.929) (17000/17999=0.476) (18000/18999=0.475) (19000/19999=0.733) (20000/20999=0.111) (21000/21999=0.226) (22000/22999=0.123) (23000/23999=0.28) (24000/24999=0.798) (25000/25999=0.284) (26000/26999=0.389) (27000/27999=0.144) (28000/28999=0.129) (29000/29999=0.223) (30000/30999=0.039) (31000/31999=0.467) (32000/32999=0.561) (33000/33999=0.308) (34000/34999=0.877) (35000/35999=0.293) (36000/36999=0.159) (37000/37999=0.214) (40000/40999=0.227) (41000/41999=0.227) (45000/45999=0.034) (50000/50999=0.15) (51000/51999=0.15) (52000/52999=0.15) (55000/55999=0.026) (60000/60999=0.114) (61000/61999=0.114) (62000/62999=0.114) (63000/63999=0.114) (64000/64999=0.234) (65000/65999=0.176) (66000/66999=0.303) (67000/67999=0.055) (70000/70999=0.01) (71000/71999=0.174) (72000/72999=0.124) (73000/73999=0.074) (74000/74999=0.033) (75000/75999=.) (80000/80999=0.006) (85000/85999=0.006) (90000/90999=0.007) (91000/91999=0.007) (92000/92999=0.007) (93000/93999=0.007) (95000/95999=.) (99000/99999=.)lab var fdi2 "foreign direct investment OECD"gen fdi2a=wz93_03recode fdi2a (-9=.) (0=.) (10/19=0.006) (20/29=0.006) (50/59=0.006) (100/109=0.198) (110/119=0.198) (120/129=0.198) (130/139=0.198) (140/149=0.198) (150/159=0.073) (160/169=0.481) (170/179=0.322) (180/189=0.322) (190/199=0.423) (200/209=0.100) (210/219=0.184) (220/229=0.110) (230/239=0.219) (240/249=0.444) (250/259=0.221) (260/269=0.280) (270/279=0.126) (280/289=0.114) (290/299=0.182) (300/309=0.038) (310/319=0.318) (320/329=0.359) (330/339=0.236) (340/349=0.467) (350/359=0.226) (360/369=0.137) (370/379=0.176) (400/409=0.185) (410/419=0.185) (450/459=0.033) (500/509=0.130) (510/519=0.130) (520/529=0.130) (550/559=0.025) (600/609=0.102) (610/619=0.102) (620/629=0.102) (630/639=0.102) (640/649=0.190) (650/659=0.150) (660/669=0.232) (670/679=0.052) (700/709=0.010) (710/719=0.149) (720/729=0.110) (730/739=0.068) (740/749=0.032) (750/759=.) (800/809=0.006) (850/859=0.006) (900/909=0.007) (910/919=0.007) (920/929=0.007) (930/939=0.007) (950/959=.) (990/999=.) (1000/1999=0.006) (2000/2999=0.006) (5000/5999=0.006) (10000/10999=0.198) (11000/11999=0.198) (12000/12999=0.198) (13000/13999=0.198) (14000/14999=0.198) (15000/15999=0.073) (16000/16999=0.481) (17000/17999=0.322) (18000/18999=0.322) (19000/19999=0.423) (20000/20999=0.100) (21000/21999=0.184) (22000/22999=0.110) (23000/23999=0.219) (24000/24999=0.444) (25000/25999=0.221) (26000/26999=0.280) (27000/27999=0.126) (28000/28999=0.114) (29000/29999=0.182) (30000/30999=0.038) (31000/31999=0.318) (32000/32999=0.359) (33000/33999=0.236) (34000/34999=0.467) (35000/35999=0.226) (36000/36999=0.137) (37000/37999=0.176) (40000/40999=0.185) (41000/41999=0.185) (45000/45999=0.033) (50000/50999=0.130) (51000/51999=0.130) (52000/52999=0.130) (55000/55999=0.025) (60000/60999=0.102) (61000/61999=0.102) (62000/62999=0.102) (63000/63999=0.102) (64000/64999=0.190) (65000/65999=0.150) (66000/66999=0.232) (67000/67999=0.052) (70000/70999=0.010) (71000/71999=0.149) (72000/72999=0.110) (73000/73999=0.068) (74000/74999=0.032) (75000/75999=.) (80000/80999=0.006) (85000/85999=0.006) (90000/90999=0.007) (91000/91999=0.007) (92000/92999=0.007) (93000/93999=0.007) (95000/95999=.) (99000/99999=.)lab var fdi2a "foreign direct investment OECDa"gen fdi2b=wz93_03recode fdi2b (-9=.) (0=.) (10/19=0.006) (20/29=0.006) (50/59=0.006) (100/109=0.211) (110/119=0.211) (120/129=0.211) (130/139=0.211) (140/149=0.211) (150/159=0.077) (160/169=0.722) (170/179=0.34) (180/189=0.349) (190/199=0.44) (200/209=0.104) (210/219=0.242) (220/229=0.114) (230/239=0.318) (240/249=0.521) (250/259=0.256) (260/269=0.307) (270/279=0.15) (280/289=0.124) (290/299=0.208) (300/309=0.095) (310/319=0.349) (320/329=0.5) (330/339=0.28) (340/349=0.513) (350/359=0.350) (360/369=0.143) (370/379=0.188) (400/409=0.194) (410/419=0.194) (450/459=0.033) (500/509=0.138) (510/519=0.138) (520/529=0.138) (550/559=0.026) (600/609=0.106) (610/619=0.106) (620/629=0.106) (630/639=0.106) (640/649=0.208) (650/659=0.155) (660/669=0.245) (670/679=0.053) (700/709=0.01) (710/719=0.163) (720/729=0.118) (730/739=0.072) (740/749=0.034) (750/759=.) (800/809=0.006) (850/859=0.006) (900/909=0.007) (910/919=0.007) (920/929=0.007) (930/939=0.007) (950/959=.) (990/999=.) (1000/1999=0.006) (2000/2999=0.006) (5000/5999=0.006) (10000/10999=0.211) (11000/11999=0.211) (12000/12999=0.211) (13000/13999=0.211) (14000/14999=0.211) (15000/15999=0.077) (16000/16999=0.722) (17000/17999=0.34) (18000/18999=0.349) (19000/19999=0.44) (20000/20999=0.104) (21000/21999=0.242) (22000/22999=0.114) (23000/23999=0.318) (24000/24999=0.521) (25000/25999=0.256) (26000/26999=0.307) (27000/27999=0.15) (28000/28999=0.124) (29000/29999=0.208) (30000/30999=0.095) (31000/31999=0.349) (32000/32999=0.5) (33000/33999=0.28) (34000/34999=0.513) (35000/35999=0.350) (36000/36999=0.143) (37000/37999=0.188) (40000/40999=0.194) (41000/41999=0.194) (45000/45999=0.033) (50000/50999=0.138) (51000/51999=0.138) (52000/52999=0.138) (55000/55999=0.026) (60000/60999=0.106) (61000/61999=0.106) (62000/62999=0.106) (63000/63999=0.106) (64000/64999=0.208) (65000/65999=0.155) (66000/66999=0.245) (67000/67999=0.053) (70000/70999=0.01) (71000/71999=0.163) (72000/72999=0.118) (73000/73999=0.072) (74000/74999=0.034) (75000/75999=.) (80000/80999=0.006) (85000/85999=0.006) (90000/90999=0.007) (91000/91999=0.007) (92000/92999=0.007) (93000/93999=0.007) (95000/95999=.) (99000/99999=.)lab var fdi2b "foreign direct investment OECDb"gen inwfdi2=wz93_03recode inwfdi2 (-9=.) (0=.) (10/19=0.004) (20/29=0.004) (50/59=0.004) (100/109=0.076) (110/119=0.076) (120/129=0.076) (130/139=0.076) (140/149=0.076) (150/159=0.06) (160/169=0.643) (170/179=0.077) (180/189=0.113) (190/199=0.067) (200/209=0.039) (210/219=0.293) (220/229=0.042) (230/239=0.4) (240/249=0.265) (250/259=0.176) (260/269=0.122) (270/279=0.18) (280/289=0.085) (290/299=0.15) (300/309=0.627) (310/319=0.128) (320/329=0.439) (330/339=0.207) (340/349=0.169) (350/359=0.456) (360/369=0.046) (370/379=0.071) (400/409=0.057) (410/419=0.057) (450/459=0.017) (500/509=0.066) (510/519=0.066) (520/529=0.066) (550/559=0.04) (600/609=0.036) (610/619=0.036) (620/629=0.036) (630/639=0.036) (640/649=0.109) (650/659=0.042) (660/669=0.066) (670/679=0.02) (700/709=0.008) (710/719=0.105) (720/729=0.075) (730/739=0.059) (740/749=0.049) (750/759=.) (800/809=0.001) (850/859=0.001) (900/909=0.009) (910/919=0.009) (920/929=0.009) (930/939=0.009) (950/959=.) (990/999=.) (1000/1999=0.004) (2000/2999=0.004) (5000/5999=0.004) (10000/10999=0.076) (11000/11999=0.076) (12000/12999=0.076) (13000/13999=0.076) (14000/14999=0.076) (15000/15999=0.06) (16000/16999=0.643) (17000/17999=0.077) (18000/18999=0.113) (19000/19999=0.067) (20000/20999=0.039) (21000/21999=0.293) (22000/22999=0.042) (23000/23999=0.4) (24000/24999=0.265) (25000/25999=0.176) (26000/26999=0.122) (27000/27999=0.18) (28000/28999=0.085) (29000/29999=0.15) (30000/30999=0.627) (31000/31999=0.128) (32000/32999=0.439) (33000/33999=0.207) (34000/34999=0.169) (35000/35999=0.456) (36000/36999=0.046) (37000/37999=0.071) (40000/40999=0.057) (41000/41999=0.057) (45000/45999=0.017) (50000/50999=0.066) (51000/51999=0.066) (52000/52999=0.066) (55000/55999=0.04) (60000/60999=0.036) (61000/61999=0.036) (62000/62999=0.036) (63000/63999=0.036) (64000/64999=0.109) (65000/65999=0.042) (66000/66999=0.066) (67000/67999=0.02) (70000/70999=0.008) (71000/71999=0.105) (72000/72999=0.075) (73000/73999=0.059) (74000/74999=0.049) (75000/75999=.) (80000/80999=0.001) (85000/85999=0.001) (90000/90999=0.009) (91000/91999=0.009) (92000/92999=0.009) (93000/93999=0.009) (95000/95999=.) (99000/99999=.)lab var inwfdi2 "inward foreign direct investment OECD" gen totfdi2=wz93_03recode totfdi2 (	-9	=	.	) (	0	=	.	) (	10/19	=	0.01	) (	20/29	=	0.01	) (	50/59	=	0.01	) (	100/109	=	0.324	) (	110/119	=	0.324	) (	120/129	=	0.324	) (	130/139	=	0.324	) (	140/149	=	0.324	) (	150/159	=	0.139	) (	160/169	=	1.571	) (	170/179	=	0.552	) (	180/189	=	0.588	) (	190/199	=	0.8	) (	200/209	=	0.15	) (	210/219	=	0.518	) (	220/229	=	0.165	) (	230/239	=	0.68	) (	240/249	=	1.063	) (	250/259	=	0.46	) (	260/269	=	0.51	) (	270/279	=	0.324	) (	280/289	=	0.214	) (	290/299	=	0.373	) (	300/309	=	0.667	) (	310/319	=	0.595	) (	320/329	=	1	) (	330/339	=	0.515	) (	340/349	=	1.045	) (	350/359	=	0.748	) (	360/369	=	0.205	) (	370/379	=	0.286	) (	400/409	=	0.284	) (	410/419	=	0.284	) (	450/459	=	0.051	) (	500/509	=	0.216	) (	510/519	=	0.216	) (	520/529	=	0.216	) (	550/559	=	0.065	) (	600/609	=	0.15	) (	610/619	=	0.15	) (	620/629	=	0.15	) (	630/639	=	0.15	) (	640/649	=	0.344	) (	650/659	=	0.218	) (	660/669	=	0.369	) (	670/679	=	0.075	) (	700/709	=	0.018	) (	710/719	=	0.279	) (	720/729	=	0.199	) (	730/739	=	0.132	) (	740/749	=	0.083	) (	750/759	=	.	) (	800/809	=	0.007	) (	850/859	=	0.007	) (	900/909	=	0.016	) (	910/919	=	0.016	) (	920/929	=	0.016	) (	930/939	=	0.016	) (	950/959	=	.	) (	990/999	=	.	) (	1000/1999	=	0.01	) (	2000/2999	=	0.01	) (	5000/5999	=	0.01	) (	10000/10999	=	0.324	) (	11000/11999	=	0.324	) (	12000/12999	=	0.324	) (	13000/13999	=	0.324	) (	14000/14999	=	0.324	) (	15000/15999	=	0.139	) (	16000/16999	=	1.571	) (	17000/17999	=	0.552	) (	18000/18999	=	0.588	) (	19000/19999	=	0.8	) (	20000/20999	=	0.15	) (	21000/21999	=	0.518	) (	22000/22999	=	0.165	) (	23000/23999	=	0.68	) (	24000/24999	=	1.063	) (	25000/25999	=	0.46	) (	26000/26999	=	0.51	) (	27000/27999	=	0.324	) (	28000/28999	=	0.214	) (	29000/29999	=	0.373	) (	30000/30999	=	0.667	) (	31000/31999	=	0.595	) (	32000/32999	=	1	) (	33000/33999	=	0.515	) (	34000/34999	=	1.045	) (	35000/35999	=	0.748	) (	36000/36999	=	0.205	) (	37000/37999	=	0.286	) (	40000/40999	=	0.284	) (	41000/41999	=	0.284	) (	45000/45999	=	0.051	) (	50000/50999	=	0.216	) (	51000/51999	=	0.216	) (	52000/52999	=	0.216	) (	55000/55999	=	0.065	) (	60000/60999	=	0.15	) (	61000/61999	=	0.15	) (	62000/62999	=	0.15	) (	63000/63999	=	0.15	) (	64000/64999	=	0.344	) (	65000/65999	=	0.218	) (	66000/66999	=	0.369	) (	67000/67999	=	0.075	) (	70000/70999	=	0.018	) (	71000/71999	=	0.279	) (	72000/72999	=	0.199	) (	73000/73999	=	0.132	) (	74000/74999	=	0.083	) (	75000/75999	=	.	) (	80000/80999	=	0.007	) (	85000/85999	=	0.007	) (	90000/90999	=	0.016	) (	91000/91999	=	0.016	) (	92000/92999	=	0.016	) (	93000/93999	=	0.016	) (	95000/95999	=	.	) (	99000/99999	=	.	)lab var totfdi2 "total foreign direct investment OECD"gen totfdi2a=wz93_03recode totfdi2a (	-9	=	.	) (	0	=	.	) (	10/19	=	0.01	) (	20/29	=	0.01	) (	50/59	=	0.01	) (	100/109	=	0.26	) (	110/119	=	0.26	) (	120/129	=	0.26	) (	130/139	=	0.26	) (	140/149	=	0.26	) (	150/159	=	0.129	) (	160/169	=	0.815	) (	170/179	=	0.374	) (	180/189	=	0.398	) (	190/199	=	0.462	) (	200/209	=	0.135	) (	210/219	=	0.423	) (	220/229	=	0.147	) (	230/239	=	0.531	) (	240/249	=	0.591	) (	250/259	=	0.358	) (	260/269	=	0.367	) (	270/279	=	0.283	) (	280/289	=	0.189	) (	290/299	=	0.305	) (	300/309	=	0.642	) (	310/319	=	0.406	) (	320/329	=	0.641	) (	330/339	=	0.394	) (	340/349	=	0.557	) (	350/359	=	0.579	) (	360/369	=	0.177	) (	370/379	=	0.235	) (	400/409	=	0.232	) (	410/419	=	0.232	) (	450/459	=	0.049	) (	500/509	=	0.188	) (	510/519	=	0.188	) (	520/529	=	0.188	) (	550/559	=	0.064	) (	600/609	=	0.134	) (	610/619	=	0.134	) (	620/629	=	0.134	) (	630/639	=	0.134	) (	640/649	=	0.278	) (	650/659	=	0.185	) (	660/669	=	0.283	) (	670/679	=	0.071	) (	700/709	=	0.017	) (	710/719	=	0.238	) (	720/729	=	0.177	) (	730/739	=	0.123	) (	740/749	=	0.08	) (	750/759	=	.	) (	800/809	=	0.007	) (	850/859	=	0.007	) (	900/909	=	0.016	) (	910/919	=	0.016	) (	920/929	=	0.016	) (	930/939	=	0.016	) (	950/959	=	.	) (	990/999	=	.	) (	1000/1999	=	0.01	) (	2000/2999	=	0.01	) (	5000/5999	=	0.01	) (	10000/10999	=	0.26	) (	11000/11999	=	0.26	) (	12000/12999	=	0.26	) (	13000/13999	=	0.26	) (	14000/14999	=	0.26	) (	15000/15999	=	0.129	) (	16000/16999	=	0.815	) (	17000/17999	=	0.374	) (	18000/18999	=	0.398	) (	19000/19999	=	0.462	) (	20000/20999	=	0.135	) (	21000/21999	=	0.423	) (	22000/22999	=	0.147	) (	23000/23999	=	0.531	) (	24000/24999	=	0.591	) (	25000/25999	=	0.358	) (	26000/26999	=	0.367	) (	27000/27999	=	0.283	) (	28000/28999	=	0.189	) (	29000/29999	=	0.305	) (	30000/30999	=	0.642	) (	31000/31999	=	0.406	) (	32000/32999	=	0.641	) (	33000/33999	=	0.394	) (	34000/34999	=	0.557	) (	35000/35999	=	0.579	) (	36000/36999	=	0.177	) (	37000/37999	=	0.235	) (	40000/40999	=	0.232	) (	41000/41999	=	0.232	) (	45000/45999	=	0.049	) (	50000/50999	=	0.188	) (	51000/51999	=	0.188	) (	52000/52999	=	0.188	) (	55000/55999	=	0.064	) (	60000/60999	=	0.134	) (	61000/61999	=	0.134	) (	62000/62999	=	0.134	) (	63000/63999	=	0.134	) (	64000/64999	=	0.278	) (	65000/65999	=	0.185	) (	66000/66999	=	0.283	) (	67000/67999	=	0.071	) (	70000/70999	=	0.017	) (	71000/71999	=	0.238	) (	72000/72999	=	0.177	) (	73000/73999	=	0.123	) (	74000/74999	=	0.08	) (	75000/75999	=	.	) (	80000/80999	=	0.007	) (	85000/85999	=	0.007	) (	90000/90999	=	0.016	) (	91000/91999	=	0.016	) (	92000/92999	=	0.016	) (	93000/93999	=	0.016	) (	95000/95999	=	.	) (	99000/99999	=	.	)lab var totfdi2a "total foreign direct investment OECDa"gen trade2=wz93_03recode trade2 (-9=.) (0=.) (10/19=0.450) (20/29=0.450) (50/59=1.578) (100/109=5.879) (110/119=5.879) (120/129=5.879) (130/139=0.831) (140/149=0.831) (150/159=0.375) (160/169=0.535) (170/179=1.880) (180/189=2.065) (190/199=2.573) (200/209=0.375) (210/219=0.872) (220/229=0.173) (230/239=0.508) (240/249=1.130) (250/259=0.639) (260/269=0.415) (270/279=0.907) (280/289=0.358) (290/299=0.820) (300/309=3.247) (310/319=0.678) (320/329=2.239) (330/339=1.223) (340/349=0.790) (350/359=1.929) (360/369=.) (370/379=.) (400/409=.) (410/419=.) (450/459=0.046) (500/509=.) (510/519=.) (520/529=.) (550/559=.) (600/609=0.181) (610/619=1.484) (620/629=0.873) (630/639=0.061) (640/649=0.069) (650/659=0.089) (660/669=0.053) (670/679=.) (700/709=.) (710/719=.) (720/729=0.229) (730/739=0.617) (740/749=0.001) (750/759=0.039) (800/809=.) (850/859=.) (900/909=0.007) (910/919=0.007) (920/929=0.007) (930/939=0.007) (950/959=.) (990/999=.) (1000/1999=0.450) (2000/2999=0.450) (5000/5999=1.578) (10000/10999=5.879) (11000/11999=5.879) (12000/12999=5.879) (13000/13999=0.831) (14000/14999=0.831) (15000/15999=0.375) (16000/16999=0.535) (17000/17999=1.880) (18000/18999=2.065) (19000/19999=2.573) (20000/20999=0.375) (21000/21999=0.872) (22000/22999=0.173) (23000/23999=0.508) (24000/24999=1.130) (25000/25999=0.639) (26000/26999=0.415) (27000/27999=0.907) (28000/28999=0.358) (29000/29999=0.820) (30000/30999=3.247) (31000/31999=0.678) (32000/32999=2.239) (33000/33999=1.223) (34000/34999=0.790) (35000/35999=1.929) (36000/36999=.) (37000/37999=.) (40000/40999=.) (41000/41999=.) (45000/45999=0.046) (50000/50999=.) (51000/51999=.) (52000/52999=.) (55000/55999=.) (60000/60999=0.810) (61000/61999=1.484) (62000/62999=0.873) (63000/63999=0.061) (64000/64999=0.069) (65000/65999=0.089) (66000/66999=0.053) (67000/67999=.) (70000/70999=.) (71000/71999=.) (72000/72999=0.229) (73000/73999=0.617) (74000/74999=0.001) (75000/75999=0.039) (80000/80999=.) (85000/85999=.) (90000/90999=0.007) (91000/91999=0.007) (92000/92999=0.007) (93000/93999=0.007) (95000/95999=.) (99000/99999=.)lab var trade2 "total trade OECD"gen netxrat2=wz93_03recode netxrat2 (-9=.) (0=.) (10/19=-0.229) (20/29=-0.229) (50/59=-0.773) (100/109=-5.753) (110/119=-5.753) (120/129=-5.753) (130/139=-0.489) (140/149=-0.489) (150/159=-0.025) (160/169=0.249) (170/179=-0.112) (180/189=-0.855) (190/199=-1.023) (200/209=-0.022) (210/219=0.029) (220/229=0.033) (230/239=-0.092) (240/249=0.182) (250/259=0.137) (260/269=0.039) (270/279=0.038) (280/289=0.073) (290/299=0.325) (300/309=-0.915) (310/319=0.089) (320/329=-0.088) (330/339=0.248) (340/349=0.301) (350/359=0.200) (360/369=.) (370/379=.) (400/409=.) (410/419=.) (450/459=-0.005) (500/509=.) (510/519=.) (520/529=.) (550/559=.) (600/609=-0.071) (610/619=0.023) (620/629=0.095) (630/639=-0.040) (640/649=-0.022) (650/659=0.005) (660/669=0.008) (670/679=.) (700/709=.) (710/719=.) (720/729=-0.027) (730/739=-0.115) (740/749=0.000) (750/759=0.021) (800/809=.) (850/859=.) (900/909=0.000) (910/919=0.000) (920/929=0.000) (930/939=0.000) (950/959=.) (990/999=.) (1000/1999=-0.229) (2000/2999=-0.229) (5000/5999=-0.773) (10000/10999=-5.753) (11000/11999=-5.753) (12000/12999=-5.753) (13000/13999=-0.489) (14000/14999=-0.489) (15000/15999=-0.025) (16000/16999=0.249) (17000/17999=-0.112) (18000/18999=-0.855) (19000/19999=-1.023) (20000/20999=-0.022) (21000/21999=0.029) (22000/22999=0.033) (23000/23999=-0.092) (24000/24999=0.182) (25000/25999=0.137) (26000/26999=0.039) (27000/27999=0.038) (28000/28999=0.073) (29000/29999=0.325) (30000/30999=-0.915) (31000/31999=0.089) (32000/32999=-0.088) (33000/33999=0.248) (34000/34999=0.301) (35000/35999=0.200) (36000/36999=.) (37000/37999=.) (40000/40999=.) (41000/41999=.) (45000/45999=-0.005) (50000/50999=.) (51000/51999=.) (52000/52999=.) (55000/55999=.) (60000/60999=-0.082) (61000/61999=0.023) (62000/62999=0.095) (63000/63999=-0.040) (64000/64999=-0.022) (65000/65999=0.005) (66000/66999=0.008) (67000/67999=.) (70000/70999=.) (71000/71999=.) (72000/72999=-0.027) (73000/73999=-0.115) (74000/74999=0.000) (75000/75999=0.021) (80000/80999=.) (85000/85999=.) (90000/90999=0.000) (91000/91999=0.000) (92000/92999=0.000) (93000/93999=0.000) (95000/95999=.) (99000/99999=.)lab var netxrat2 "net export rate OECD"gen xdep2=wz93_03recode xdep2 (-9=.) (0=.) (10/19=0.11) (20/29=0.11) (50/59=0.402) (100/109=0.063) (110/119=0.063) (120/129=0.063) (130/139=0.171) (140/149=0.171) (150/159=0.175) (160/169=0.392) (170/179=0.884) (180/189=0.605) (190/199=0.775) (200/209=0.177) (210/219=0.451) (220/229=0.103) (230/239=0.208) (240/249=0.656) (250/259=0.388) (260/269=0.227) (270/279=0.473) (280/289=0.215) (290/299=0.572) (300/309=1.166) (310/319=0.384) (320/329=1.075) (330/339=0.735) (340/349=0.546) (350/359=1.065) (360/369=.) (370/379=.) (400/409=.) (410/419=.) (450/459=0.02) (500/509=.) (510/519=.) (520/529=.) (550/559=.) (600/609=0.055) (610/619=0.753) (620/629=0.484) (630/639=0.01) (640/649=0.024) (650/659=0.047) (660/669=0.031) (670/679=.) (700/709=.) (710/719=.) (720/729=0.101) (730/739=0.251) (740/749=0.001) (750/759=0.03) (800/809=.) (850/859=.) (900/909=0.004) (910/919=0.004) (920/929=0.004) (930/939=0.004) (950/959=.) (990/999=.) (1000/1999=0.11) (2000/2999=0.11) (5000/5999=0.402) (10000/10999=0.063) (11000/11999=0.063) (12000/12999=0.063) (13000/13999=0.171) (14000/14999=0.171) (15000/15999=0.175) (16000/16999=0.392) (17000/17999=0.884) (18000/18999=0.605) (19000/19999=0.775) (20000/20999=0.177) (21000/21999=0.451) (22000/22999=0.103) (23000/23999=0.208) (24000/24999=0.656) (25000/25999=0.388) (26000/26999=0.227) (27000/27999=0.473) (28000/28999=0.215) (29000/29999=0.572) (30000/30999=1.166) (31000/31999=0.384) (32000/32999=1.075) (33000/33999=0.735) (34000/34999=0.546) (35000/35999=1.065) (36000/36999=.) (37000/37999=.) (40000/40999=.) (41000/41999=.) (45000/45999=0.02) (50000/50999=.) (51000/51999=.) (52000/52999=.) (55000/55999=.) (60000/60999=0.055) (61000/61999=0.753) (62000/62999=0.484) (63000/63999=0.01) (64000/64999=0.024) (65000/65999=0.047) (66000/66999=0.031) (67000/67999=.) (70000/70999=.) (71000/71999=.) (72000/72999=0.101) (73000/73999=0.251) (74000/74999=0.001) (75000/75999=0.03) (80000/80999=.) (85000/85999=.) (90000/90999=0.004) (91000/91999=0.004) (92000/92999=0.004) (93000/93999=0.004) (95000/95999=.) (99000/99999=.)lab var xdep2 "export dependency OECD"
gen xdep2_full=wz93_03
recode xdep2_full (-9=.) (0=.) (10/19=0.11) (20/29=0.11) (50/59=0.402) (100/109=0.063) (110/119=0.063) (120/129=0.063) (130/139=0.171) (140/149=0.171) (150/159=0.175) (160/169=0.392) (170/179=0.884) (180/189=0.605) (190/199=0.775) (200/209=0.177) (210/219=0.451) (220/229=0.103) (230/239=0.208) (240/249=0.656) (250/259=0.388) (260/269=0.227) (270/279=0.473) (280/289=0.215) (290/299=0.572) (300/309=1.166) (310/319=0.384) (320/329=1.075) (330/339=0.735) (340/349=0.546) (350/359=1.065) (360/369=0) (370/379=0) (400/409=0) (410/419=0) (450/459=0.02) (500/509=0) (510/519=0) (520/529=0) (550/559=0) (600/609=0.055) (610/619=0.753) (620/629=0.484) (630/639=0.01) (640/649=0.024) (650/659=0.047) (660/669=0.031) (670/679=0) (700/709=0) (710/719=0) (720/729=0.101) (730/739=0.251) (740/749=0.001) (750/759=0.03) (800/809=0) (850/859=0) (900/909=0.004) (910/919=0.004) (920/929=0.004) (930/939=0.004) (950/959=0) (990/999=0) (1000/1999=0.11) (2000/2999=0.11) (5000/5999=0.402) (10000/10999=0.063) (11000/11999=0.063) (12000/12999=0.063) (13000/13999=0.171) (14000/14999=0.171) (15000/15999=0.175) (16000/16999=0.392) (17000/17999=0.884) (18000/18999=0.605) (19000/19999=0.775) (20000/20999=0.177) (21000/21999=0.451) (22000/22999=0.103) (23000/23999=0.208) (24000/24999=0.656) (25000/25999=0.388) (26000/26999=0.227) (27000/27999=0.473) (28000/28999=0.215) (29000/29999=0.572) (30000/30999=1.166) (31000/31999=0.384) (32000/32999=1.075) (33000/33999=0.735) (34000/34999=0.546) (35000/35999=1.065) (36000/36999=0) (37000/37999=0) (40000/40999=0) (41000/41999=0) (45000/45999=0.02) (50000/50999=0) (51000/51999=0) (52000/52999=0) (55000/55999=0) (60000/60999=0.055) (61000/61999=0.753) (62000/62999=0.484) (63000/63999=0.01) (64000/64999=0.024) (65000/65999=0.047) (66000/66999=0.031) (67000/67999=0) (70000/70999=0) (71000/71999=0) (72000/72999=0.101) (73000/73999=0.251) (74000/74999=0.001) (75000/75999=0.03) (80000/80999=0) (85000/85999=0) (90000/90999=0.004) (91000/91999=0.004) (92000/92999=0.004) (93000/93999=0.004) (95000/95999=0) (99000/99999=0)
lab var xdep2_full "export dependency OECD full"

gen xdep2tradeableA=wz93_03
recode xdep2tradeableA (-9=.) (0=.) (10/19=0.11) (20/29=0.11) (50/59=0.402) (100/109=0.063) (110/119=0.063) (120/129=0.063) (130/139=0.171) (140/149=0.171) (150/159=0.175) (160/169=0.392) (170/179=0.884) (180/189=0.605) (190/199=0.775) (200/209=0.177) (210/219=0.451) (220/229=0.103) (230/239=0.208) (240/249=0.656) (250/259=0.388) (260/269=0.227) (270/279=0.473) (280/289=0.215) (290/299=0.572) (300/309=1.166) (310/319=0.384) (320/329=1.075) (330/339=0.735) (340/349=0.546) (350/359=1.065) (360/369=.) (370/379=.) (400/409=.) (410/419=.) (450/459=.) (500/509=.) (510/519=.) (520/529=.) (550/559=.) (600/609=0.055) (610/619=0.753) (620/629=0.484) (630/639=.) (640/649=.) (650/659=.) (660/669=.) (670/679=.) (700/709=.) (710/719=.) (720/729=0.101) (730/739=0.251) (740/749=.) (750/759=.) (800/809=.) (850/859=.) (900/909=.) (910/919=.) (920/929=.) (930/939=.) (950/959=.) (990/999=.) (1000/1999=0.11) (2000/2999=0.11) (5000/5999=0.402) (10000/10999=0.063) (11000/11999=0.063) (12000/12999=0.063) (13000/13999=0.171) (14000/14999=0.171) (15000/15999=0.175) (16000/16999=0.392) (17000/17999=0.884) (18000/18999=0.605) (19000/19999=0.775) (20000/20999=0.177) (21000/21999=0.451) (22000/22999=0.103) (23000/23999=0.208) (24000/24999=0.656) (25000/25999=0.388) (26000/26999=0.227) (27000/27999=0.473) (28000/28999=0.215) (29000/29999=0.572) (30000/30999=1.166) (31000/31999=0.384) (32000/32999=1.075) (33000/33999=0.735) (34000/34999=0.546) (35000/35999=1.065) (36000/36999=.) (37000/37999=.) (40000/40999=.) (41000/41999=.) (45000/45999=.) (50000/50999=.) (51000/51999=.) (52000/52999=.) (55000/55999=.) (60000/60999=0.055) (61000/61999=0.753) (62000/62999=0.484) (63000/63999=.) (64000/64999=.) (65000/65999=.) (66000/66999=.) (67000/67999=.) (70000/70999=.) (71000/71999=.) (72000/72999=0.101) (73000/73999=0.251) (74000/74999=.) (75000/75999=.) (80000/80999=.) (85000/85999=.) (90000/90999=.) (91000/91999=.) (92000/92999=.) (93000/93999=.) (95000/95999=.) (99000/99999=.)
lab var xdep2tradeableA "export dependency OECD tradeable A"

gen xdep2tradeableB=wz93_03
recode xdep2tradeableB (-9=.) (0=.) (10/19=0.11) (20/29=0.11) (50/59=0.402) (100/109=0.063) (110/119=0.063) (120/129=0.063) (130/139=0.171) (140/149=0.171) (150/159=0.175) (160/169=0.392) (170/179=0.884) (180/189=0.605) (190/199=0.775) (200/209=0.177) (210/219=0.451) (220/229=0.103) (230/239=0.208) (240/249=0.656) (250/259=0.388) (260/269=0.227) (270/279=0.473) (280/289=0.215) (290/299=0.572) (300/309=1.166) (310/319=0.384) (320/329=1.075) (330/339=0.735) (340/349=0.546) (350/359=1.065) (360/369=.) (370/379=.) (400/409=.) (410/419=.) (450/459=0.02) (500/509=.) (510/519=.) (520/529=.) (550/559=.) (600/609=0.055) (610/619=0.753) (620/629=0.484) (630/639=.) (640/649=0.024) (650/659=0.047) (660/669=0.031) (670/679=.) (700/709=.) (710/719=.) (720/729=0.101) (730/739=0.251) (740/749=.) (750/759=0.03) (800/809=.) (850/859=.) (900/909=.) (910/919=.) (920/929=.) (930/939=.) (950/959=.) (990/999=.) (1000/1999=0.11) (2000/2999=0.11) (5000/5999=0.402) (10000/10999=0.063) (11000/11999=0.063) (12000/12999=0.063) (13000/13999=0.171) (14000/14999=0.171) (15000/15999=0.175) (16000/16999=0.392) (17000/17999=0.884) (18000/18999=0.605) (19000/19999=0.775) (20000/20999=0.177) (21000/21999=0.451) (22000/22999=0.103) (23000/23999=0.208) (24000/24999=0.656) (25000/25999=0.388) (26000/26999=0.227) (27000/27999=0.473) (28000/28999=0.215) (29000/29999=0.572) (30000/30999=1.166) (31000/31999=0.384) (32000/32999=1.075) (33000/33999=0.735) (34000/34999=0.546) (35000/35999=1.065) (36000/36999=.) (37000/37999=.) (40000/40999=.) (41000/41999=.) (45000/45999=0.02) (50000/50999=.) (51000/51999=.) (52000/52999=.) (55000/55999=.) (60000/60999=0.055) (61000/61999=0.753) (62000/62999=0.484) (63000/63999=.) (64000/64999=0.024) (65000/65999=0.047) (66000/66999=0.031) (67000/67999=.) (70000/70999=.) (71000/71999=.) (72000/72999=0.101) (73000/73999=0.251) (74000/74999=.) (75000/75999=0.03) (80000/80999=.) (85000/85999=.) (90000/90999=.) (91000/91999=.) (92000/92999=.) (93000/93999=.) (95000/95999=.) (99000/99999=.)
lab var xdep2tradeableB "export dependency OECD tradeable B"
gen mpen2=wz93_03recode mpen2 (-9=.) (0=.) (10/19=0.34) (20/29=0.34) (50/59=1.176) (100/109=5.816) (110/119=5.816) (120/129=5.816) (130/139=0.66) (140/149=0.66) (150/159=0.2) (160/169=0.143) (170/179=0.996) (180/189=1.46) (190/199=1.798) (200/209=0.199) (210/219=0.421) (220/229=0.07) (230/239=0.3) (240/249=0.474) (250/259=0.251) (260/269=0.188) (270/279=0.434) (280/289=0.142) (290/299=0.248) (300/309=2.081) (310/319=0.295) (320/329=1.163) (330/339=0.488) (340/349=0.244) (350/359=0.864) (360/369=.) (370/379=.) (400/409=.) (410/419=.) (450/459=0.025) (500/509=.) (510/519=.) (520/529=.) (550/559=.) (600/609=0.126) (610/619=0.731) (620/629=0.389) (630/639=0.051) (640/649=0.045) (650/659=0.042) (660/669=0.022) (670/679=.) (700/709=.) (710/719=.) (720/729=0.128) (730/739=0.366) (740/749=0.000) (750/759=0.009) (800/809=.) (850/859=.) (900/909=0.004) (910/919=0.004) (920/929=0.004) (930/939=0.004) (950/959=.) (990/999=.) (1000/1999=0.34) (2000/2999=0.34) (5000/5999=1.176) (10000/10999=5.816) (11000/11999=5.816) (12000/12999=5.816) (13000/13999=0.66) (14000/14999=0.66) (15000/15999=0.2) (16000/16999=0.143) (17000/17999=0.996) (18000/18999=1.46) (19000/19999=1.798) (20000/20999=0.199) (21000/21999=0.421) (22000/22999=0.07) (23000/23999=0.3) (24000/24999=0.474) (25000/25999=0.251) (26000/26999=0.188) (27000/27999=0.434) (28000/28999=0.142) (29000/29999=0.248) (30000/30999=2.081) (31000/31999=0.295) (32000/32999=1.163) (33000/33999=0.488) (34000/34999=0.244) (35000/35999=0.864) (36000/36999=.) (37000/37999=.) (40000/40999=.) (41000/41999=.) (45000/45999=0.025) (50000/50999=.) (51000/51999=.) (52000/52999=.) (55000/55999=.) (60000/60999=0.126) (61000/61999=0.731) (62000/62999=0.389) (63000/63999=0.051) (64000/64999=0.045) (65000/65999=0.042) (66000/66999=0.022) (67000/67999=.) (70000/70999=.) (71000/71999=.) (72000/72999=0.128) (73000/73999=0.366) (74000/74999=0.000) (75000/75999=0.009) (80000/80999=.) (85000/85999=.) (90000/90999=0.004) (91000/91999=0.004) (92000/92999=0.004) (93000/93999=0.004) (95000/95999=.) (99000/99999=.)lab var mpen2 "import penetration OECD"**FINALLY, we need to construct some interaction terms* using the above globalization measures with the works council dummy (wc) :gen iwcforsales=wc*forsaleslab var iwcforsales "interaction term works council with foreign sales"gen iwcexport=wc*exportlab var iwcexport "interaction term works council with export-orientation dummy"gen iwcexport10=wc*export10lab var iwcexport10 "interaction term works council with export-orientation 10% dummy"gen iwcexport20=wc*export20lab var iwcexport20 "ineteraction term works council with export-orientation 20% dummy"gen iwcexport25=wc*export25lab var iwcexport25 "ineteraction term works council with export-orientation 25% dummy"gen iwcforownership=wc*forownershiplab var iwcforownership "interaction term works council with foreign ownership"gen iwcfdi2=wc*fdi2lab var iwcfdi2 "interaction term works council with fdi2"gen iwcfdi2a=wc*fdi2alab var iwcfdi2a "interaction term works council with fdi2a"gen iwcfdi2b=wc*fdi2blab var iwcfdi2b "interaction term works council with fdi2b"gen iwcinwfdi2=wc*inwfdi2lab var iwcinwfdi2 "interaction term works council with inwfdi2"gen iwctotfdi2=wc*totfdi2lab var iwctotfdi2 "interaction term works council with totfdi2"gen iwctotfdi2a=wc*totfdi2alab var iwctotfdi2a "interaction term works council with totfdi2a"gen iwctrade2=wc*trade2lab var iwctrade2 "interaction term works council with trade2"gen iwcnetxrat2=wc*netxrat2 lab var iwcnetxrat2 "interaction term works council with netxrat2"gen iwcxdep2=wc*xdep2lab var iwcxdep2 "interaction term works council with xdep2"
gen iwcxdep2_full=wc*xdep2_full
lab var iwcxdep2_full "interaction term works council with xdep2 full"

gen iwcxdep2tradeableA=wc*xdep2tradeableA
lab var iwcxdep2tradeableA "interaction term works council with xdep2tradeableA"

gen iwcxdep2tradeableB=wc*xdep2tradeableB
lab var xdep2tradeableB "interaction term works council with xdep2tradeableB"
gen iwcmpen2=wc*mpen2lab var iwcmpen2 "interaction term works council with mpen2"* one mesure of establishment level export-orientation with an industry-level globalization measuregen iforsalestotfdi2a = forsales * totfdi2agen iexporttotfdi2a = export * totfdi2agen iexport10totfdi2a = export10 * totfdi2agen iexport20totfdi2a = export20 *totfdi2agen iexport25totfdi2a = export25 *totfdi2agen iforsalestrade2 = forsales * trade2gen iexporttrade2 = export * trade2gen iexport10trade2 = export10 * trade2gen iexport20trade2 = export20 * trade2gen iexport25trade2 = export25 * trade2* using the above globalization measures with the pattern bargaining dummy :gen ipatternbargforsales=patternbarg*forsaleslab var ipatternbargforsales "interaction term patternbarg with foreign sales"gen ipatternbargforownership=patternbarg*forownershiplab var ipatternbargforownership "interaction term patternbarg with foreign ownership"gen ipatternbargtotfdi2a=patternbarg*totfdi2alab var ipatternbargtotfdi2a "interaction term patternbarg with totfdi2a"gen ipatternbargtotfdi2=patternbarg*totfdi2lab var ipatternbargtotfdi2a "interaction term patternbarg with totfdi2"gen ipatternbargfdi2a=patternbarg*fdi2alab var ipatternbargfdi2a "interaction term pattern bargaining with fdi2a"gen ipatternbargfdi2b=patternbarg*fdi2blab var ipatternbargfdi2b "interaction term pattern bargaining with fdi2b"gen ipatternbargfdi2=patternbarg*fdi2lab var ipatternbargfdi2 "interaction term pattern bargaining with fdi2"gen ipatternbarginwfdi2=patternbarg*inwfdi2lab var ipatternbarginwfdi2 "interaction term works council with inwfdi2"gen ipatternbargtrade2=patternbarg*trade2lab var ipatternbargtrade2 "interaction term patternbarg with trade2"gen ipatternbargnetxrat2=patternbarg*netxrat2 lab var ipatternbargnetxrat2 "interaction term patternbarg with netxrat2"gen ipatternbargxdep2=patternbarg*xdep2lab var ipatternbargxdep2 "interaction term pattern bargaining with xdep2"gen ipatternbargmpen2=patternbarg*mpen2lab var ipatternbargmpen2 "interaction term pattern barg with mpen2"*Now we generate some dummies and categorical variables for the combinations of wc and patternbarg:*A. Dummy where 1=wc only (no pattern bargaining)gen workorgA=wcreplace workorgA=0 if patternbarg==1sum workorgA, d*A2. Dummy where 1=pattern barg. only (no works councils)gen workorgA2=patternbargreplace workorgA2=0 if wc==1sum workorgA2, d*B. Dummy where 1=both wc and patternbarg 0=only one or neither:gen workorgB=wcreplace workorgB=1 if patternbarg==1&wc==1replace workorgB=0 if patternbarg==0replace workorgB=0 if wc==0sum workorgB, d *B2. Dummy where 1=either wc and/or patternbarg; 0=neithergen workorgB2=wcreplace workorgB2=1 if patternbarg==1sum workorgB2, d*C. Categorical variable:gen workorgC=wc+patternbargsum workorgC, d*D. New "basic" interaction terms:  e.g. gen iworkorgBtotfdi2a=workorgB*totfdi2agen iworkorgAforsales=workorgA*forsalesgen iworkorgAtotfdi2a=workorgA*totfdi2agen iworkorgAtrade2=workorgA*trade2gen iworkorgAtotfdi2=workorgA*totfdi2gen iworkorgAforownership=workorgA*forownershipgen iworkorgAfdi2=workorgA*fdi2gen iworkorgAxdep2=workorgA*xdep2gen iworkorgA2forsales=workorgA2*forsalesgen iworkorgA2totfdi2a=workorgA2*totfdi2agen iworkorgA2trade2=workorgA2*trade2gen iworkorgA2totfdi2=workorgA2*totfdi2gen iworkorgA2forownership=workorgA2*forownershipgen iworkorgA2fdi2=workorgA2*fdi2gen iworkorgA2xdep2=workorgA2*xdep2gen iworkorgBforsales=workorgB*forsalesgen iworkorgBtotfdi2a=workorgB*totfdi2agen iworkorgBtrade2=workorgB*trade2gen iworkorgBtotfdi2=workorgB*totfdi2gen iworkorgBforownership=workorgB*forownershipgen iworkorgBfdi2=workorgB*fdi2gen iworkorgBxdep2=workorgB*xdep2gen iworkorgB2forsales=workorgB2*forsalesgen iworkorgB2totfdi2a=workorgB2*totfdi2agen iworkorgB2trade2=workorgB2*trade2gen iworkorgB2totfdi2=workorgB2*totfdi2gen iworkorgB2forownership=workorgB2*forownershipgen iworkorgB2fdi2=workorgB2*fdi2gen iworkorgB2xdep2=workorgB2*xdep2gen iworkorgCforsales=workorgC*forsalesgen iworkorgCtotfdi2a=workorgC*totfdi2agen iworkorgCtrade2=workorgC*trade2gen iworkorgCtotfdi2=workorgC*totfdi2gen iworkorgCforownership=workorgC*forownershipgen iworkorgCfdi2=workorgC*fdi2gen iworkorgCxdep2=workorgC*xdep2*E. New wcpatternbarg interaction term:gen iwcpatternbarg=wc*patternbarg *F. New triple interaction term:gen iwcpatternbargforsales=iwcpatternbarg*forsalesgen iwcpatternbargtotfdi2a=iwcpatternbarg*totfdi2agen iwcpatternbargtrade2=iwcpatternbarg*trade2gen iwcpatternbargtotfdi2=iwcpatternbarg*totfdi2gen iwcpatternbargforownership=iwcpatternbarg*forownershipgen iwcpatternbarginwfdi2=iwcpatternbarg*inwfdi2gen iwcpatternbargfdi2=iwcpatternbarg*fdi2gen iwcpatternbargxdep2=iwcpatternbarg*xdep2gen iwcforsalestrade2=wc*forsales*trade2gen iwcforsalestotfdi2a=wc*forsales*totfdi2agen iwcexporttrade2=wc*export*trade2gen iwcexporttotfdi2a=wc*export*totfdi2agen iwcexport10trade2=wc*export10*trade2gen iwcexport10totfdi2a=wc*export10*totfdi2agen iwcexport20trade2=wc*export20*trade2gen iwcexport20totfdi2a=wc*export20*totfdi2agen iwcexport25trade2=wc*export25*trade2gen iwcexport25totfdi2a=wc*export25*totfdi2asave data\test2002_new_RaessCS02.dta, replacelog close